FaStudentAY_Proxy

Logical Entity Name | FaStudentAY_Proxy
Default Table Name | FaStudentAY_Proxy
Physical Only | NO
Owner | dbo
Definition |
Note |

FaStudentAY_Proxy Columns

ColumnName | Domain | Datatype | NULL | Definition
FaStudentAY_ProxyID |  | bigint | NO |
TableName |  | varchar(255) | NO |
RecordID |  | int | NO |
AdEnrollID |  | int | NO |
Sequence |  | int | NO |
OldFaPackStatusID |  | int | NO |
NewFaPackStatusID |  | int | NO |
OldAdGradeLevelID |  | int | NO |
NewAdGradeLevelID |  | int | NO |
OldTuition |  | money | YES |
NewTuition |  | money | YES |
OldBooksSupplies |  | money | YES |
NewBooksSupplies |  | money | YES |
OldRoomBoard |  | money | YES |
NewRoomBoard |  | money | YES |
OldTravel |  | money | YES |
NewTravel |  | money | YES |
OldBankFees |  | money | NO |
NewBankFees |  | money | NO |
OldOtherAmount1 |  | money | YES |
NewOtherAmount1 |  | money | YES |
OldOtherInst1 |  | bit | NO |
NewOtherInst1 |  | bit | NO |
OldOtherDescrip1 |  | varchar(40) | YES |
NewOtherDescrip1 |  | varchar(40) | YES |
OldOtherAmount2 |  | money | YES |
NewOtherAmount2 |  | money | YES |
OldOtherInst2 |  | bit | NO |
NewOtherInst2 |  | bit | NO |
OldOtherDescrip2 |  | varchar(40) | YES |
NewOtherDescrip2 |  | varchar(40) | YES |
OldOtherAmount3 |  | money | YES |
NewOtherAmount3 |  | money | YES |
OldOtherInst3 |  | bit | NO |
NewOtherInst3 |  | bit | NO |
OldOtherDescrip3 |  | varchar(40) | YES |
NewOtherDescrip3 |  | varchar(40) | YES |
OldOtherAmount4 |  | money | YES |
NewOtherAmount4 |  | money | YES |
OldOtherInst4 |  | bit | NO |
NewOtherInst4 |  | bit | NO |
OldOtherDescrip4 |  | varchar(40) | YES |
NewOtherDescrip4 |  | varchar(40) | YES |
OldOtherAmount5 |  | money | YES |
NewOtherAmount5 |  | money | YES |
OldOtherInst5 |  | bit | NO |
NewOtherInst5 |  | bit | NO |
OldOtherDescrip5 |  | varchar(40) | YES |
NewOtherDescrip5 |  | varchar(40) | YES |
OldOtherAmount6 |  | money | YES |
NewOtherAmount6 |  | money | YES |
OldOtherInst6 |  | bit | NO |
NewOtherInst6 |  | bit | NO |
OldOtherDescrip6 |  | varchar(40) | YES |
NewOtherDescrip6 |  | varchar(40) | YES |
OldOtherAmount7 |  | money | YES |
NewOtherAmount7 |  | money | YES |
OldOtherInst7 |  | bit | NO |
NewOtherInst7 |  | bit | NO |
OldOtherDescrip7 |  | varchar(40) | YES |
NewOtherDescrip7 |  | varchar(40) | YES |
OldOtherAmount8 |  | money | YES |
NewOtherAmount8 |  | money | YES |
OldOtherInst8 |  | bit | NO |
NewOtherInst8 |  | bit | NO |
OldOtherDescrip8 |  | varchar(40) | YES |
NewOtherDescrip8 |  | varchar(40) | YES |
Comment |  | varchar(400) | YES |
UserID |  | int | NO |
ModFlag |  | char(1) | YES |
NewStartDate |  | datetime | YES |
NewEndDate |  | datetime | YES |
OldStartDate |  | datetime | YES |
OldEndDate |  | datetime | YES |
OldAwardYear2FAPackStatusID |  | int | YES |
NewAwardYear2FAPackStatusID |  | int | YES |
OldUnsupportedDependent |  | bit | NO |
NewUnsupportedDependent |  | bit | NO |
DateAdded |  | datetime | NO |
OldExcludeStartDate |  | bit | YES |
NewExcludeStartDate |  | bit | YES |
OldExcludeEndDate |  | bit | YES |
NewExcludeEndDate |  | bit | YES |
NewCreditHoursInAY |  | numeric(7, 2) | YES |
OldCreditHoursInAY |  | numeric(7, 2) | YES |
NewWeeksInAY |  | numeric(5, 2) | YES |
OldWeeksInAY |  | numeric(5, 2) | YES |
NewIWINAY |  | numeric(4, 1) | YES |
OldIWINAY |  | numeric(4, 1) | YES |
NewIWMonths |  | numeric(4, 1) | YES |
OldIWMonths |  | numeric(4, 1) | YES |
OldFaAutoAwardPopulationConfigurationId |  | int | YES |
NewFaAutoAwardPopulationConfigurationId |  | int | YES |
OldIsAllowProrateDL |  | bit | YES |
NewIsAllowProrateDL |  | bit | YES |
OldPellCostOfAttend |  | money | YES |
NewPellCostOfAttend |  | money | YES |
OldExcludeFromMTF |  | bit | YES |
NewExcludeFromMTF |  | bit | YES |
OldBooksSuppliesInst |  | bit | YES |
NewBooksSuppliesInst |  | bit | YES |
OldRoomBoardInst |  | bit | YES |
NewRoomBoardInst |  | bit | YES |
OldTravelInst |  | bit | YES |
NewTravelInst |  | bit | YES |

FaStudentAY_Proxy Primary and Unique Keys

Key Name | Key Type | Keys
FaStudentAY_Proxy_FaStudentAY_ProxyID_U_C_IDX | PrimaryKey | FaStudentAY_ProxyID

FaStudentAY_Proxy Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaStudentAY_Proxy Check Constraints

Check Constraint Name | CheckConstraint

FaStudentAY_Proxy Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaStudentAY_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaStudentAY_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentAY_Proxy | NO |  |  |

FaStudentAY_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaStudentAY_Proxy Data Movement Rules

Name | Type | Rule Text/Value